This window will enable you to produce reports of Loan amounts that fell due and were paid on the due date. You will be able to see the principal, interest and penalty amounts recovered.
How to view the repayments past due report.
To view the Repayments Past Due report you go to Loans/Portfolio Reports/Repayments of Dues Report. A screen that looks as follows will appear:
Report date from: In the drop down box, select the date when the report should start e.g. "01/01/2020" and in to drop down box select the date when the report should end e.g., "07/10/2014".
Check if report with clients address: When this option is selected, the repayments of dues report will include the addresses for the clients that have made the payments otherwise if unchecked the addresses will be excluded.
Report Currency: From the drop down list select the currency in which the report should appear, e.g., "UGX".
Note that Loan Performer offers the flexibility of displaying the report in different currencies.
Branch Code: From the drop down box, select the branch for which the repayments of dues report should be generated or tick the For all option to generate the report for all branches.
Credit officer: Select from the drop down box a particular credit officer whom you want to generate a report about, this may be to see the outstanding balances on loans that were handled by that officer. You may tick the Check for all option in order to have a report on all credit officers who may have handled Loans.
Loan fund: From the drop down box, select a particular loan fund that you want to generate a report for. You may tick the Check for all option to have a report on all funds that are available in the system.
Geographical area: From the drop down box, select a particular geographical area that you want to generate a report for. You may tick the Check for all option to have a report on all geographical areas.
Loan product: From the drop down box, select a loan product that you want to generate a report about. You may tick the Check for all option to have a report on all loan products that are available in the system.
Business Sector: From the drop down box, select a business sector from which you want to generate a report about. You may tick the Check for all option to have a report on all business sectors that are available in the system.
Cost Center: From the drop down box, select a cost center for which you want to generate a report about. You may tick the Check for all option to have a report on all business sectors that are available in the system.
Grouping/Order: Select from the drop down box how the report to be generated will be classified in the column title/heading, e.g, "Loan Product". The report generated will hence be grouped per loan product.
Report Format: Select from the drop down box the sequence in which the column titles in your report should appear. Loan Performer offers a variety of formats for you to choose from, e.g., "Format (1)".
Client Category 1: From the drop down box, select a client based on the classification that you made at Menu Support Files Client Category 1 / Client Category 2 and Client Category 3. You may tick the Check for all option to have a report on all options under each client category.
Loan Category 1: From the drop down box, select a classification of a loan that you made at Menu Support Files/Loan Category 1 / Loan Category 2 and Loan Category 3. You may tick the Check for all option to have a report on all options under each loan category.
Guarantee Items: Select a class of items that were used as security for loans from the drop down box. You may tick the Check for all option to have a report on all the different classes that are available in the system.
Additional filtering options? :This option is used to get a particular field or specification that you want. It helps you to narrow down the information that you need. When you check this option and click OK, a pop up screen will appear that looks as follows
From the Filter Criteria drop-down, select the fields that you want to use, e.g. "LAMOUNT", and select the Relational Operator to use e.g., "<=" and then enter the Value e.g., "200,000".
Note that if you need further filtering you select the Logical Operator, e.g., ""and" / 'Or" and then proceed to select the Filter Criteria, Relational Operator and Values as seen above.
Click the OK button if all the data entered is sufficient. You will get a pop up message confirming what you have entered that looks as follows;
Click the Yes button to generate a repayments of dues report for the selected filter criteria. The filtered report will look different from the unfiltered one and will have only a few clients in conformity to selection criteria.
Select any other required additional options or use the default selections. For additional information on these options you can refer to Portfolio Report Formats.
Click on the OK to generate the repayments of dues report that will look as follows: